<?php

require_once '../common/conn.php';

$db = new DBC();
//$sql = "SELECT code,name FROM t_market_suggest ORDER BY num";
$sql = "SELECT p.* FROM t_market_suggest s LEFT JOIN t_product p ON s.code = p.flashcode ORDER BY s.num";
$data = $db->fetchData($sql);

echo json_encode($data);
?>